Query Caching
Pyramid uses caching to speed up the re-use of the same query result set without re-querying the underlying data source for the exact same results. When caching is enabled, the query result set of any previously executed queries is temporarily stored in memory on Pyramid's servers. The length of time for which the query results are stored is set by the administrator in the query cache settings.
Why Use Query Caching?
Query caching is enabled by default, because it improves speed when executing the same query multiple times. Disabling query caching ensures that query results are up to date (real-time), rather than cached.
Enable or Disable Caching
Caching is enabled by default; toggle the 'Disable Cache' button from the Configuration ribbon or the Tables ribbon to turn of all caching for the data model.
Caching can also be enabled or disabled for the same data model from the source manager in the Admin console, and from Discover.